<!--frm_script_db_objects.cfm -->
<cfinclude template="qry_db_objects.cfm" />

<!--- <cfdump var="#rs#"> --->
<form name="frmDBobj" id="frmDBobj" action="act_generate_files_code.cfm" method="post">
		<input type="submit" value="Generate" class="button" accesskey="S" /><br clear="all" />

Select DB objects to generate files and code, then click the Generate button.
<table class="userInput">
	<caption>
		DB objects
	</caption>
	<thead>
		<tr>
			<th><input type="checkbox" class="c" id="selectAll_1" onclick="checkAll(this,this.form.table_name);" /></th>
			<th>table</th>
			<th>columns</th>
		</tr>
	</thead>
	<tbody>
		<cfoutput query="rs" group="table_name">
		<tr>
			<td><input type="checkbox" class="c" name="table_name" id="table_name_#rs.table_name#" value="#rs.table_name#" /></td>
			<td><label for="table_name_#rs.table_name#" class="inline">#rs.table_name#</label></td>
			<td>
				<ul>
				<cfoutput><li><cfif rs.is_identity eq 'Y'>
							<img src="/Image/icons/information.gif" title="Identity" alt="Identity" />
							</cfif><cfif rs.primary_key eq 'Y'>
							<img src="/Image/icons/table_key.gif" title="Primary Key" alt="Primary Key" />
								</cfif>#rs.column_name# (#rs.data_type#)</li>
								</cfoutput>
				</ul></td>
		</tr>
		</cfoutput>
	</tbody>
	<tfoot>
		<tr>
			<td colspan="3">
				<input type="submit" value="Generate" class="button" accesskey="S" />
			</td>
		</tr>
	</tfoot>
</table>
</form>